Pandas Profiling Report

Dataset statistics

Number of variables	21
Number of observations	1246
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	654.6 KiB
Average record size in memory	538.0 B

Variable types

NUM	15
CAT	5
UNSUPPORTED	1

Reproduction

Analysis started	2021-03-06 12:29:46.997948
Analysis finished	2021-03-06 12:30:20.247348
Duration	33.25 seconds
Version	pandas-profiling v2.7.1
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

`title` has a high cardinality: 1238 distinct values	High cardinality
`deltaMedianPrice` is highly correlated with `deltaAvgPrice`	High correlation
`deltaAvgPrice` is highly correlated with `deltaMedianPrice`	High correlation
`dublinNorthSouth` is highly correlated with `neighbourhood`	High correlation
`neighbourhood` is highly correlated with `dublinNorthSouth`	High correlation
`title` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`floorArea` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`deltaMedianPrice` has 50 (4.0%) zeros	Zeros

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct count	1246
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1439.1958266452648
Minimum	2
Maximum	2904
Zeros	0
Zeros (%)	0.0%
Memory size	9.9 KiB

Quantile statistics

Minimum	2
5-th percentile	184.5
Q1	802.25
median	1453.5
Q3	2067.25
95-th percentile	2703.25
Maximum	2904
Range	2902
Interquartile range (IQR)	1265

Descriptive statistics

Standard deviation	778.831748
Coefficient of variation (CV)	0.541157592
Kurtosis	-1.038071287
Mean	1439.195827
Median Absolute Deviation (MAD)	635
Skewness	0.0174243834
Sum	1793238
Variance	606578.8917

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2092	1	0.1%
1297	1	0.1%
1311	1	0.1%
1310	1	0.1%
1309	1	0.1%
1307	1	0.1%
1305	1	0.1%
1302	1	0.1%
1299	1	0.1%
1295	1	0.1%
Other values (1236)	1236	99.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	1	0.1%
11	1	0.1%
13	1	0.1%
14	1	0.1%
15	1	0.1%

Value	Count	Frequency (%)
2904	1	0.1%
2902	1	0.1%
2899	1	0.1%
2893	1	0.1%
2884	1	0.1%

title
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	1238
Unique (%)	99.4%
Missing	0
Missing (%)	0.0%
Memory size	9.9 KiB

Apartment 101, Milltown Hall, Milltown Avenue, Mount Saint Annes, Milltown, Dublin 6	2
1 Fitzgibbon Lane, Dublin 1	2
20 Muckross Green, Perrystown, Dublin 12	2
20 Moyclare Road, Baldoyle, Dublin 13	2
88 Scholarstown Park, Rathfarnham, Dublin 16	2
Other values (1233)	1236

Value	Count	Frequency (%)
Apartment 101, Milltown Hall, Milltown Avenue, Mount Saint Annes, Milltown, Dublin 6	2	0.2%
1 Fitzgibbon Lane, Dublin 1	2	0.2%
20 Muckross Green, Perrystown, Dublin 12	2	0.2%
20 Moyclare Road, Baldoyle, Dublin 13	2	0.2%
88 Scholarstown Park, Rathfarnham, Dublin 16	2	0.2%
Apartment 427, The Old Chocolate Factory, Kilmainham Square, Kilmainham, Dublin 8	2	0.2%
171 Drimnagh Road, Drimnagh, Dublin 12	2	0.2%
24 The Wood, Millbrook Lawns, Tallaght, Dublin 24	2	0.2%
Apartment 15, Blackhall Court, Stoneybatter, Dublin 7	1	0.1%
193 Annamoe Drive, Cabra, Dublin 7	1	0.1%
Other values (1228)	1228	98.6%

Length

Max length	84
Mean length	45.20545746
Min length	22

Value	Count	Frequency (%)
Lowercase_Letter	27	38.0%
Uppercase_Letter	25	35.2%
Decimal_Number	10	14.1%
Other_Punctuation	4	5.6%
Open_Punctuation	1	1.4%
Connector_Punctuation	1	1.4%
Dash_Punctuation	1	1.4%
Close_Punctuation	1	1.4%
Space_Separator	1	1.4%

Value	Count	Frequency (%)
Latin	52	73.2%
Common	19	26.8%

Value	Count	Frequency (%)
ASCII	70	100.0%

neighbourhood
Categorical

HIGH CORRELATION

Distinct count	22
Unique (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	9.9 KiB

Dublin 15	129
Dublin 11	96
Dublin 8	91
Dublin 3	76
Dublin 4	75
Other values (17)	779

Value	Count	Frequency (%)
Dublin 15	129	10.4%
Dublin 11	96	7.7%
Dublin 8	91	7.3%
Dublin 3	76	6.1%
Dublin 4	75	6.0%
Dublin 14	71	5.7%
Dublin 7	70	5.6%
Dublin 9	70	5.6%
Dublin 24	69	5.5%
Dublin 6	66	5.3%
Other values (12)	433	34.8%

Length

Max length	9
Mean length	8.543338684
Min length	8

Value	Count	Frequency (%)
Decimal_Number	10	55.6%
Lowercase_Letter	5	27.8%
Uppercase_Letter	2	11.1%
Space_Separator	1	5.6%

Value	Count	Frequency (%)
Common	11	61.1%
Latin	7	38.9%

Value	Count	Frequency (%)
ASCII	18	100.0%

propertyType
Categorical

Distinct count	9
Unique (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	9.9 KiB

Apartment	388
Terrace	335
Semi-D	267
End of Terrace	112
Detached	65
Other values (4)	79

Value	Count	Frequency (%)
Apartment	388	31.1%
Terrace	335	26.9%
Semi-D	267	21.4%
End of Terrace	112	9.0%
Detached	65	5.2%
Duplex	33	2.6%
Bungalow	20	1.6%
Townhouse	13	1.0%
Site	13	1.0%

Length

Max length	14
Mean length	8.069020867
Min length	4

Value	Count	Frequency (%)
Lowercase_Letter	19	70.4%
Uppercase_Letter	6	22.2%
Space_Separator	1	3.7%
Dash_Punctuation	1	3.7%

Value	Count	Frequency (%)
Latin	25	92.6%
Common	2	7.4%

Value	Count	Frequency (%)
ASCII	27	100.0%

numBedrooms
Real number (ℝ)

Distinct count	9
Unique (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.601123595505618
Minimum	-1.0
Maximum	11.0
Zeros	0
Zeros (%)	0.0%
Memory size	9.9 KiB

Quantile statistics

Minimum	-1
5-th percentile	1
Q1	2
median	3
Q3	3
95-th percentile	4
Maximum	11
Range	12
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.011880601
Coefficient of variation (CV)	0.3890167322
Kurtosis	5.195947532
Mean	2.601123596
Median Absolute Deviation (MAD)	1
Skewness	0.4453117177
Sum	3241
Variance	1.023902351

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
3	512	41.1%
2	448	36.0%
4	123	9.9%
1	108	8.7%
5	37	3.0%
-1	13	1.0%
6	2	0.2%
7	2	0.2%
11	1	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	13	1.0%
1	108	8.7%
2	448	36.0%
3	512	41.1%
4	123	9.9%

Value	Count	Frequency (%)
11	1	0.1%
7	2	0.2%
6	2	0.2%
5	37	3.0%
4	123	9.9%

numBathrooms
Real number (ℝ)

Distinct count	7
Unique (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.6404494382022472
Minimum	-1.0
Maximum	6.0
Zeros	0
Zeros (%)	0.0%
Memory size	9.9 KiB

Quantile statistics

Minimum	-1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	3
Maximum	6
Range	7
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.8553734469
Coefficient of variation (CV)	0.5214262792
Kurtosis	1.742502726
Mean	1.640449438
Median Absolute Deviation (MAD)	1
Skewness	0.6844891597
Sum	2044
Variance	0.7316637336

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	619	49.7%
2	429	34.4%
3	152	12.2%
4	24	1.9%
-1	16	1.3%
5	5	0.4%
6	1	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	16	1.3%
1	619	49.7%
2	429	34.4%
3	152	12.2%
4	24	1.9%

Value	Count	Frequency (%)
6	1	0.1%
5	5	0.4%
4	24	1.9%
3	152	12.2%
2	429	34.4%

floorArea
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	9.9 KiB

price
Real number (ℝ_≥0)

Distinct count	187
Unique (%)	15.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	394611.5569823435
Minimum	75000.0
Maximum	2500000.0
Zeros	0
Zeros (%)	0.0%
Memory size	9.9 KiB

Quantile statistics

Minimum	75000
5-th percentile	195000
Q1	260000
median	347000
Q3	450000
95-th percentile	795000
Maximum	2500000
Range	2425000
Interquartile range (IQR)	190000

Descriptive statistics

Standard deviation	221645.0652
Coefficient of variation (CV)	0.5616791026
Kurtosis	21.70185396
Mean	394611.557
Median Absolute Deviation (MAD)	97000
Skewness	3.471018183
Sum	491686000
Variance	4.912653493e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
275000	43	3.5%
350000	36	2.9%
395000	33	2.6%
250000	33	2.6%
375000	32	2.6%
425000	31	2.5%
295000	29	2.3%
450000	28	2.2%
285000	27	2.2%
325000	27	2.2%
Other values (177)	927	74.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
75000	1	0.1%
95000	1	0.1%
129000	1	0.1%
130000	1	0.1%
135000	2	0.2%

Value	Count	Frequency (%)
2500000	2	0.2%
2300000	1	0.1%
1800000	1	0.1%
1700000	1	0.1%
1600000	2	0.2%

rating
Categorical

Distinct count	16
Unique (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	9.9 KiB

D2	169
D1	153
C3	127
C2	123
C1	109
Other values (11)	565

Value	Count	Frequency (%)
D2	169	13.6%
D1	153	12.3%
C3	127	10.2%
C2	123	9.9%
C1	109	8.7%
E1	93	7.5%
B3	91	7.3%
E2	84	6.7%
F	72	5.8%
G	70	5.6%
Other values (6)	155	12.4%

Length

Max length	6
Mean length	2.073033708
Min length	1

Value	Count	Frequency (%)
Uppercase_Letter	10	66.7%
Decimal_Number	4	26.7%
Connector_Punctuation	1	6.7%

Value	Count	Frequency (%)
Latin	10	66.7%
Common	5	33.3%

Value	Count	Frequency (%)
ASCII	15	100.0%

sellerId
Real number (ℝ_≥0)

Distinct count	192
Unique (%)	15.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5680.025682182985
Minimum	7
Maximum	11902
Zeros	0
Zeros (%)	0.0%
Memory size	9.9 KiB

Quantile statistics

Minimum	7
5-th percentile	12
Q1	1367
median	6589
Q3	9780.75
95-th percentile	11062
Maximum	11902
Range	11895
Interquartile range (IQR)	8413.75

Descriptive statistics

Standard deviation	4234.030495
Coefficient of variation (CV)	0.7454245336
Kurtosis	-1.658130317
Mean	5680.025682
Median Absolute Deviation (MAD)	4358
Skewness	-0.05738117281
Sum	7077312
Variance	17927014.23

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
11062	47	3.8%
10947	40	3.2%
7569	39	3.1%
11	36	2.9%
1413	31	2.5%
12	30	2.4%
8505	28	2.2%
10948	25	2.0%
6498	24	1.9%
1590	23	1.8%
Other values (182)	923	74.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
7	5	0.4%
11	36	2.9%
12	30	2.4%
49	16	1.3%
56	8	0.6%

Value	Count	Frequency (%)
11902	8	0.6%
11766	4	0.3%
11754	1	0.1%
11720	2	0.2%
11635	1	0.1%

longitude
Real number (ℝ)

Distinct count	1213
Unique (%)	97.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-6.281458683215653
Minimum	-6.443882
Maximum	-6.055211
Zeros	0
Zeros (%)	0.0%
Memory size	9.9 KiB

Quantile statistics

Minimum	-6.443882
5-th percentile	-6.4040685
Q1	-6.3227085
median	-6.276811362
Q3	-6.23546
95-th percentile	-6.166198
Maximum	-6.055211
Range	0.388671
Interquartile range (IQR)	0.0872485

Descriptive statistics

Standard deviation	0.07159854719
Coefficient of variation (CV)	-0.01139839499
Kurtosis	-0.09202510834
Mean	-6.281458683
Median Absolute Deviation (MAD)	0.0432255
Skewness	-0.06818282502
Sum	-7826.697519
Variance	0.00512635196

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
-6.280268	3	0.2%
-6.227282	3	0.2%
-6.309374	3	0.2%
-6.255195	3	0.2%
-6.249849	2	0.2%
-6.236223	2	0.2%
-6.282985	2	0.2%
-6.264954	2	0.2%
-6.172943	2	0.2%
-6.27907	2	0.2%
Other values (1203)	1222	98.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-6.443882	1	0.1%
-6.443585	1	0.1%
-6.442693	1	0.1%
-6.441123	1	0.1%
-6.440754	1	0.1%

Value	Count	Frequency (%)
-6.055211	1	0.1%
-6.059735	1	0.1%
-6.060574	1	0.1%
-6.065742	1	0.1%
-6.066756	1	0.1%

latitude
Real number (ℝ_≥0)

Distinct count	1212
Unique (%)	97.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	53.34361547308575
Minimum	53.21904
Maximum	53.433172
Zeros	0
Zeros (%)	0.0%
Memory size	9.9 KiB

Quantile statistics

Minimum	53.21904
5-th percentile	53.2703605
Q1	53.31696425
median	53.345332
Q3	53.38013025
95-th percentile	53.40117515
Maximum	53.433172
Range	0.214132
Interquartile range (IQR)	0.063166

Descriptive statistics

Standard deviation	0.04196819851
Coefficient of variation (CV)	0.0007867520441
Kurtosis	-0.6699352258
Mean	53.34361547
Median Absolute Deviation (MAD)	0.0316203
Skewness	-0.3924448249
Sum	66466.14488
Variance	0.001761329686

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
53.341431	3	0.2%
53.352292	3	0.2%
53.342931	3	0.2%
53.33827	3	0.2%
53.263563	2	0.2%
53.347308	2	0.2%
53.351807	2	0.2%
53.270019	2	0.2%
53.337848	2	0.2%
53.358979	2	0.2%
Other values (1202)	1222	98.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
53.21904	1	0.1%
53.226358	1	0.1%
53.229695	1	0.1%
53.231998	1	0.1%
53.233244	1	0.1%

Value	Count	Frequency (%)
53.433172	1	0.1%
53.432174	1	0.1%
53.431643	1	0.1%
53.422947	1	0.1%
53.422316	1	0.1%

pricePerBedroom
Real number (ℝ)

Distinct count	296
Unique (%)	23.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	148864.50928686082
Minimum	-1500000.0
Maximum	625000.0
Zeros	0
Zeros (%)	0.0%
Memory size	9.9 KiB

Quantile statistics

Minimum	-1500000
5-th percentile	78333.33333
Q1	108333.3333
median	140000
Q3	187500
95-th percentile	275000
Maximum	625000
Range	2125000
Interquartile range (IQR)	79166.66667

Descriptive statistics

Standard deviation	100543.2572
Coefficient of variation (CV)	0.6754011264
Kurtosis	81.14470276
Mean	148864.5093
Median Absolute Deviation (MAD)	37500
Skewness	-5.624114421
Sum	185485178.6
Variance	1.010894658e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
125000	35	2.8%
150000	29	2.3%
175000	26	2.1%
137500	20	1.6%
187500	19	1.5%
112500	18	1.4%
95000	18	1.4%
162500	18	1.4%
131666.6667	18	1.4%
165000	18	1.4%
Other values (286)	1027	82.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1500000	1	0.1%
-850000	2	0.2%
-745000	1	0.1%
-498000	1	0.1%
-350000	1	0.1%

Value	Count	Frequency (%)
625000	2	0.2%
600000	1	0.1%
497500	1	0.1%
460000	1	0.1%
450000	2	0.2%

deltaAvgPrice
Real number (ℝ)

HIGH CORRELATION

Distinct count	792
Unique (%)	63.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	21526.905914686624
Minimum	-1792406.779661017
Maximum	477593.220338983
Zeros	0
Zeros (%)	0.0%
Memory size	9.9 KiB

Quantile statistics

Minimum	-1792406.78
5-th percentile	-271524.2718
Q1	-41514.87395
median	46190.47619
Q3	110927.5701
95-th percentile	276727.7977
Maximum	477593.2203
Range	2270000
Interquartile range (IQR)	152442.444

Descriptive statistics

Standard deviation	194006.1943
Coefficient of variation (CV)	9.01226563
Kurtosis	20.23748455
Mean	21526.90591
Median Absolute Deviation (MAD)	76795.41446
Skewness	-2.952729132
Sum	26822524.77
Variance	3.763840343e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
68274.28571	8	0.6%
91384	7	0.6%
-33894.73684	7	0.6%
64732.75862	6	0.5%
66384	6	0.5%
73274.28571	6	0.5%
32338.23529	6	0.5%
282593.2203	6	0.5%
-83616	6	0.5%
43117.64706	5	0.4%
Other values (782)	1183	94.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1792406.78	2	0.2%
-1592406.78	1	0.1%
-1321524.272	1	0.1%
-1065801.802	1	0.1%
-992661.7647	1	0.1%

Value	Count	Frequency (%)
477593.2203	1	0.1%
457593.2203	1	0.1%
435198.1982	1	0.1%
417593.2203	1	0.1%
412593.2203	2	0.2%

deltaMedianPrice
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct count	279
Unique (%)	22.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-29088.28250401284
Minimum	-2005000.0
Maximum	350000.0
Zeros	50
Zeros (%)	4.0%
Memory size	9.9 KiB

Quantile statistics

Minimum	-2005000
5-th percentile	-350000
Q1	-70000
median	5000
Q3	67000
95-th percentile	175000
Maximum	350000
Range	2355000
Interquartile range (IQR)	137000

Descriptive statistics

Standard deviation	195458.1566
Coefficient of variation (CV)	-6.719480829
Kurtosis	27.48900418
Mean	-29088.2825
Median Absolute Deviation (MAD)	68000
Skewness	-3.831784753
Sum	-36244000
Variance	3.8203891e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	50	4.0%
5000	29	2.3%
50000	27	2.2%
30000	25	2.0%
70000	25	2.0%
-50000	23	1.8%
25000	22	1.8%
60000	21	1.7%
15000	20	1.6%
-100000	19	1.5%
Other values (269)	985	79.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-2005000	2	0.2%
-1805000	1	0.1%
-1405000	1	0.1%
-1175000	1	0.1%
-1105000	2	0.2%

Value	Count	Frequency (%)
350000	1	0.1%
326000	1	0.1%
320000	1	0.1%
300000	1	0.1%
290000	2	0.2%

dublinNorthSouth
Categorical

HIGH CORRELATION

Distinct count	2
Unique (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	9.9 KiB

S	652
N	594

Value	Count	Frequency (%)
S	652	52.3%
N	594	47.7%

Length

Max length	1
Mean length	1
Min length	1

Value	Count	Frequency (%)
Uppercase_Letter	2	100.0%

Value	Count	Frequency (%)
Latin	2	100.0%

Value	Count	Frequency (%)
ASCII	2	100.0%

distToCity
Real number (ℝ_≥0)

Distinct count	1216
Unique (%)	97.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5.952106407950893
Minimum	0.09991156306907832
Maximum	17.012878032749462
Zeros	0
Zeros (%)	0.0%
Memory size	9.9 KiB

Quantile statistics

Minimum	0.09991156307
5-th percentile	1.374030424
Q1	3.038546883
median	5.177323871
Q3	8.74487627
95-th percentile	12.29646768
Maximum	17.01287803
Range	16.91296647
Interquartile range (IQR)	5.706329387

Descriptive statistics

Standard deviation	3.518999816
Coefficient of variation (CV)	0.5912192383
Kurtosis	-0.6743279897
Mean	5.952106408
Median Absolute Deviation (MAD)	2.699803785
Skewness	0.4964002471
Sum	7416.324584
Variance	12.38335971

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0.2065863985	3	0.2%
3.590435795	3	0.2%
2.415355904	3	0.2%
2.213178012	3	0.2%
5.229600299	2	0.2%
4.401617511	2	0.2%
1.841780665	2	0.2%
8.438129316	2	0.2%
0.4831172059	2	0.2%
8.239632795	2	0.2%
Other values (1206)	1222	98.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.09991156307	1	0.1%
0.1835478493	1	0.1%
0.2065863985	3	0.2%
0.3172734398	1	0.1%
0.346479514	1	0.1%

Value	Count	Frequency (%)
17.01287803	1	0.1%
16.56325022	1	0.1%
16.24328956	1	0.1%
16.14727723	1	0.1%
15.94972834	1	0.1%

daysSincePublished
Real number (ℝ_≥0)

Distinct count	162
Unique (%)	13.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	77.03531300160513
Minimum	1
Maximum	345
Zeros	0
Zeros (%)	0.0%
Memory size	9.9 KiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	42
median	81
Q3	109
95-th percentile	145
Maximum	345
Range	344
Interquartile range (IQR)	67

Descriptive statistics

Standard deviation	45.70794704
Coefficient of variation (CV)	0.593337591
Kurtosis	1.887852575
Mean	77.035313
Median Absolute Deviation (MAD)	33
Skewness	0.6046360943
Sum	95986
Variance	2089.216423

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
61	32	2.6%
45	28	2.2%
110	28	2.2%
94	26	2.1%
81	26	2.1%
80	22	1.8%
108	21	1.7%
95	21	1.7%
46	21	1.7%
109	20	1.6%
Other values (152)	1001	80.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	18	1.4%
2	7	0.6%
3	16	1.3%
4	10	0.8%
5	13	1.0%

Value	Count	Frequency (%)
345	1	0.1%
342	1	0.1%
309	1	0.1%
235	2	0.2%
227	1	0.1%

numFood
Real number (ℝ_≥0)

Distinct count	47
Unique (%)	3.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	46.235955056179776
Minimum	10
Maximum	61
Zeros	0
Zeros (%)	0.0%
Memory size	9.9 KiB

Quantile statistics

Minimum	10
5-th percentile	29
Q1	42
median	49
Q3	52
95-th percentile	57
Maximum	61
Range	51
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	8.387053956
Coefficient of variation (CV)	0.1813967927
Kurtosis	1.078558764
Mean	46.23595506
Median Absolute Deviation (MAD)	4
Skewness	-1.119143875
Sum	57610
Variance	70.34267407

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
51	99	7.9%
50	92	7.4%
49	91	7.3%
52	82	6.6%
48	75	6.0%
47	74	5.9%
54	67	5.4%
53	56	4.5%
42	42	3.4%
55	40	3.2%
Other values (37)	528	42.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10	1	0.1%
13	1	0.1%
15	1	0.1%
16	1	0.1%
18	2	0.2%

Value	Count	Frequency (%)
61	2	0.2%
60	3	0.2%
59	7	0.6%
58	25	2.0%
57	29	2.3%

numRecreation
Real number (ℝ_≥0)

Distinct count	23
Unique (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11.835473515248797
Minimum	1
Maximum	23
Zeros	0
Zeros (%)	0.0%
Memory size	9.9 KiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	9
median	12
Q3	15
95-th percentile	18
Maximum	23
Range	22
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.861588419
Coefficient of variation (CV)	0.3262724059
Kurtosis	-0.3867217924
Mean	11.83547352
Median Absolute Deviation (MAD)	3
Skewness	-0.1725152429
Sum	14747
Variance	14.91186512

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
10	142	11.4%
11	134	10.8%
9	133	10.7%
15	128	10.3%
14	96	7.7%
12	95	7.6%
16	80	6.4%
13	79	6.3%
17	73	5.9%
8	57	4.6%
Other values (13)	229	18.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	3	0.2%
2	7	0.6%
3	9	0.7%
4	30	2.4%
5	40	3.2%

Value	Count	Frequency (%)
23	1	0.1%
22	1	0.1%
21	3	0.2%
20	3	0.2%
19	27	2.2%

numShop
Real number (ℝ_≥0)

Distinct count	39
Unique (%)	3.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11.406902086677368
Minimum	1
Maximum	39
Zeros	0
Zeros (%)	0.0%
Memory size	9.9 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	5
median	7
Q3	18
95-th percentile	27.75
Maximum	39
Range	38
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	8.245368696
Coefficient of variation (CV)	0.7228403149
Kurtosis	0.1792302359
Mean	11.40690209
Median Absolute Deviation (MAD)	2
Skewness	1.072014734
Sum	14213
Variance	67.98610493

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
5	313	25.1%
6	140	11.2%
7	70	5.6%
8	56	4.5%
9	55	4.4%
4	40	3.2%
20	37	3.0%
19	35	2.8%
21	35	2.8%
23	34	2.7%
Other values (29)	431	34.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	11	0.9%
2	28	2.2%
3	25	2.0%
4	40	3.2%
5	313	25.1%

Value	Count	Frequency (%)
39	1	0.1%
38	1	0.1%
37	4	0.3%
36	3	0.2%
35	5	0.4%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

First rows

	df_index	title	neighbourhood	propertyType	numBedrooms	numBathrooms	floorArea	price	rating	sellerId	longitude	latitude	pricePerBedroom	deltaAvgPrice	deltaMedianPrice	dublinNorthSouth	distToCity	daysSincePublished	numFood	numRecreation	numShop
0	2	1 Moatfield Park, Coolock, Artane, Dublin 5	Dublin 5	Semi-D	3.0	1.0	91	380000.0	E2	453	-6.193117	53.388871	126666.666667	16177.570093	0.0	N	5.857172	12	50	17	11
1	11	150 Broadford Rise, Ballinteer, Dublin 16	Dublin 16	Semi-D	3.0	2.0	102	495000.0	C3	49	-6.261108	53.277830	165000.000000	12338.235294	-20000.0	S	8.366932	9	46	9	14
2	13	Apartment 172, Block C, Dublin 7	Dublin 7	Apartment	1.0	1.0	51	250000.0	C1	1331	-6.277584	53.348715	250000.000000	127430.107527	100000.0	N	1.387431	16	51	11	5
3	14	1 Fitzgibbon Lane, Dublin 1	Dublin 1	Terrace	1.0	1.0	60	140000.0	G	11902	-6.256604	53.357853	140000.000000	176105.263158	160000.0	N	0.536232	1	57	10	5
4	15	18A Fitzgibbon Street, Dublin 1	Dublin 1	Terrace	1.0	1.0	53	240000.0	D2	11902	-6.256600	53.357783	240000.000000	76105.263158	60000.0	N	0.528618	1	57	10	5
5	19	11 Elmwood Close, Clonsilla, Dublin 15	Dublin 15	Semi-D	3.0	1.0	81	270000.0	D2	12	-6.424967	53.392171	90000.000000	73274.285714	10000.0	N	11.890627	4	45	7	25
6	40	Apartment 20, Block C, Bridge Court, Shankill, Dublin 18	Dublin 18	Apartment	2.0	2.0	71	295000.0	C2	7425	-6.123654	53.231998	147500.000000	224395.061728	130000.0	S	16.147277	2	37	15	17
7	44	15 The Belfry, Kilbarrack Road, Kilbarrack, Dublin 5	Dublin 5	Apartment	2.0	1.0	59	270000.0	C2	577	-6.152755	53.388560	135000.000000	126177.570093	110000.0	N	8.013602	4	33	15	17
8	47	3 Castlegrange Terrace, Castaheany, Clonsilla, Dublin 15	Dublin 15	Semi-D	3.0	3.0	101	300000.0	B3	8666	-6.430057	53.397993	100000.000000	43274.285714	-20000.0	N	12.449526	5	42	8	23
9	53	27 Smithfield Gate, Redcow Lane, Smithfield, Dublin 1	Dublin 1	Apartment	3.0	2.0	75	350000.0	D2	7483	-6.277353	53.349858	116666.666667	-33894.736842	-50000.0	N	1.333301	1	51	10	5

Last rows

	df_index	title	neighbourhood	propertyType	numBedrooms	numBathrooms	floorArea	price	rating	sellerId	longitude	latitude	pricePerBedroom	deltaAvgPrice	deltaMedianPrice	dublinNorthSouth	distToCity	daysSincePublished	numFood	numRecreation	numShop
1236	2866	10 Shamrock Cottages, North Strand, Dublin 3	Dublin 3	Townhouse	2.0	1.0	49	200000.0	G	2050	-6.244140	53.355253	100000.000000	278475.728155	195000.0	N	0.949914	30	55	12	5
1237	2870	5 Dun Emer Drive, Dundrum, Dublin 14	Dublin 14	Semi-D	4.0	1.0	138	645000.0	D2	49	-6.236976	53.282698	161250.000000	-42494.623656	-50000.0	S	7.946910	120	49	10	11
1238	2874	133 Kiltipper Gate, Tallaght, Dublin 24	Dublin 24	Apartment	2.0	2.0	70	215000.0	ZZZ	8210	-6.370672	53.269495	107500.000000	66532.608696	60000.0	S	11.927989	22	22	4	19
1239	2876	19 Beneavin Park, Glasnevin, Dublin 11	Dublin 11	Semi-D	3.0	1.0	97	370000.0	D2	841	-6.283289	53.389930	123333.333333	-70267.241379	-88000.0	N	4.422859	102	55	17	2
1240	2881	2 Florence Street, Portobello, Dublin 8	Dublin 8	Terrace	3.0	2.0	124	595000.0	E2	8456	-6.269723	53.331242	198333.333333	-253616.000000	-295000.0	S	2.550457	95	52	15	5
1241	2884	9 Saint Johns Court, Kilmore Road, Artane, Dublin 5	Dublin 5	Terrace	2.0	1.0	71	285000.0	C3	1063	-6.218931	53.390851	142500.000000	111177.570093	95000.0	N	4.930323	30	58	13	7
1242	2893	Apt 4, Slane House, Patrick Street, Christchurch, Dublin 8	Dublin 8	Apartment	1.0	1.0	37	230000.0	E2	6223	-6.272552	53.340047	230000.000000	111384.000000	70000.0	S	1.742339	9	56	9	5
1243	2899	4 Old Mount Pleasant, Ranelagh, Dublin 6	Dublin 6	Terrace	3.0	1.0	154	825000.0	SI_666	262	-6.258158	53.326563	275000.000000	-190801.801802	-300000.0	S	2.948946	10	51	15	6
1244	2902	10 Ard Na Greine, Eaton Brae, off Orwell Road, Rathgar, Dublin 6	Dublin 6	Terrace	2.0	2.0	144	900000.0	A3	9460	-6.261595	53.303673	450000.000000	-265801.801802	-375000.0	S	5.497794	53	46	19	9
1245	2904	3 Marian Drive, Rathfarnham, Dublin 14	Dublin 14	Detached	5.0	3.0	214	850000.0	C1	11062	-6.296157	53.295243	170000.000000	-247494.623656	-255000.0	S	6.910201	33	48	12	11

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows